package cn.vconinfo.lims.delivery.mapper;

import cn.vconinfo.lims.delivery.entity.CollectionDTO;
import cn.vconinfo.lims.delivery.entity.ProjectDTO;
import cn.vconinfo.lims.delivery.entity.UserDTO;
import cn.vconinfo.lims.delivery.model.HospitalProjectLink;
import cn.vconinfo.lims.delivery.model.WTestitemRelate;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CustomConfigMapper {

    int insertRequestItemRelateBatch(List<HospitalProjectLink> relateList);

    int insertTestItemRelateBatch(List<WTestitemRelate> relateList);

    /**
     *  实验项目list
     *
     * @param projectIdList
     * @return
     */
    List<ProjectDTO> queryProjectList(List<Long> projectIdList);


    @Select("SELECT * FROM sample_collection WHERE status = 1")
    List<CollectionDTO> getCollection();

    @Select("SELECT * FROM basic_user WHERE user_id = #{userId}")
    UserDTO getUserInfoById (@Param("userId")Long userId);


}
